# from Models.company import Company
#
# from sqlalchemy import create_engine
# from sqlalchemy.orm import sessionmaker

# 连接数据库
# engine = create_engine('mysql+pymysql://root:root@localhost:3306/people?charset=utf8')
#
# Company.metadata.create_all(engine)
# Session = sessionmaker(bind=engine)
#
# model = Session()

# data = model.query(Company).filter(Company.id == 6104).first()
#
# print(data)
#
# print('ID:{0}  {1}'.format(data.id,data.company))

# params = Company(
#     city_code=410184,
#     cat_id=3892,
#     company='tencent',
#     is_company=1,
#     contact_person='小马',
#     member=9,
#     phone='028-77667766'
# )
#
# model.add(params)
# model.commit()
# print(params.id)
